package org.example.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.example.pojo.DAmount;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.example.pojo.DStaff;
import org.example.pojo.View.AmountView;
import org.example.pojo.excel.AmountDownload;
import org.example.pojo.excel.DAmountExcel;
import org.example.pojo.select.DAmountSelect;
import org.example.utils.Result;

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
* @author chenhongkai
* @description 针对表【d_amount(宿舍水电费表)】的数据库操作Mapper
* @createDate 2024-06-06 09:17:36
* @Entity org.example.pojo.DAmount
*/
public interface DAmountMapper extends BaseMapper<DAmount> {

//    IPage<DAmount> selectAllDAmount(Page<DAmount> page, @Param("dAmountSelect") DAmountSelect dAmountSelect);

    List<String> selectAmountDate();

//    void InsertStaffAmount(DAmount dAmount);

//    void UpdateAmount(DAmount dAmount);

//    Integer selectApartmentAmount_count(DAmountSelect dAmountSelect);

    void settle(@Param("dAmountExcel") DAmountExcel dAmountExcel);

    void deleteSettle();

    int calc(String month);

    List<AmountDownload> selectDownloadAmount(String month);

    long SelectAllAmounts_total(@Param("dAmountSelect") DAmountSelect dAmountSelect);

    IPage<DAmountSelect> SelectAllAmounts(Page<DAmountSelect> page,@Param("dAmountSelect") DAmountSelect dAmountSelect);

    List<DAmountSelect> SelectAmountByApartmentId(@Param("dAmountSelect") DAmountSelect dAmountSelect);

    Double selectAllAmount();

    List<AmountView> GetEncryptionAmount(String month);
}




